Bank Reconciliation Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
Amount pDecimal 13      
BankId pBankID 10      
ClearedEntryNum int 4      
Counter int 4      
Descr varchar 30      
Reference varchar 15      
SourceId varchar 10      
TransDate datetime 8      
TransType smallint 2      
ts timestamp 8      
VoidStopYn bit 1      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
TransID pTransID 8      
GLAcct pGlAcct 40      
DebitAmt pDecimal 13 0    
DebitAmtFgn pDecimal 13 0    
CreditAmt pDecimal 13 0    
CreditAmtFgn pDecimal 13 0    
Descr nvarchar 30      
Reference nvarchar 15      
BankIDXferTo pBankID 10      
ExchRate pDecimal 13 -1    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
BankID pBankID 10      
TransType smallint 2 0 Transaction Type 2 = Deposit, 4 = Adjustment, -1 = Disbursement, -3 = Transfer
SourceID nvarchar 10      
Descr nvarchar 30      
TransDate datetime 8      
GLPeriod smallint 2 -1    
FiscalYear smallint 2 0    
Reference nvarchar 15      
Amount pDecimal 13 0    
AmountFgn pDecimal 13 0    
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
VoidYn bit 1 0    
VoidReinstateStat tinyint 1   Void Status 0 = Released, 1 = Hold, 2 = Temporary Hold
Ten99Yr tinyint 1 -1 Year for 1099 Payment 1 = Current Year, 2 = Last Year
CreateTransaction bit 1 -1    
CreateManualCheck bit 1 -1    
PayrollMonth smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
BankID pBankID 10      
TransType smallint 2 0 Transaction Type 2 = Deposit, 4 = Adjustment, -1 = Disbursement, -3 = Transfer
SourceID nvarchar 10      
Descr nvarchar 30      
Reference nvarchar 15      
SourceApp nvarchar 2      
Amount pDecimal 13 0    
AmountFgn pDecimal 13 0    
TransDate datetime 8      
FiscalYear smallint 2 0    
GlPeriod smallint 2 0    
ClearedYn bit 1 0    
VoidTransID pTransID 8      
VoidStop tinyint 1 0 Transaction Status 0 = Paid, 1 = Voided, 2 = Stopped
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
VoidDate datetime 8      
VoidPd tinyint 1 0    
VoidYear smallint 2 0    
VoidAmt pDecimal 13 0    
VoidAmtFgn pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
TransID pTransID 8      
GLAcct pGlAcct 40      
DebitAmt pDecimal 13 0    
-*DebitAmtFgn pDecimal 13 0    
CreditAmt pDecimal 13 0    
-*CreditAmtFgn pDecimal 13 0    
Descr nvarchar 30      
Reference nvarchar 15      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
BankID pBankID 10      
TransType smallint 2 -4 Transaction Type 4 = Adjustment
SourceID nvarchar 10      
Descr nvarchar 30      
TransDate datetime 8      
GLPeriod smallint 2 -1    
FiscalYear smallint 2 0    
Reference nvarchar 15      
Amount pDecimal 13 0    
-*AmountFgn pDecimal 13 0    
CurrencyId pCurrency 6      
-*ExchRate pDecimal 13 -1    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BankID pBankID 10      
BeginBalance pDecimal 13      
BeginDate datetime 8      
Description pDescription 255      
EndBalance pDecimal 13      
EndDate datetime 8      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
ID bigint 8      
Reference pDescription 255      
StatementDate datetime 8      
Status tinyint 1   Status 0 = Open, 1 = Reconciled
TransCount int 4 0    
CF xml -1      
ts timestamp 8